package com.ccxy.springboot.mapper;

import org.apache.ibatis.annotations.Mapper;
import org.apache.ibatis.annotations.Param;
import org.apache.ibatis.annotations.Select;
        import org.springframework.stereotype.Repository;

        import java.util.List;
        import java.util.Map;

@Mapper
@Repository
public interface BootMapper {
    @Select("select * from people where username=#{username} and password=#{password}")
    public List<Map> login(Map map);

    @Select("Select chinese,adcode from city")
    public List<Map> querycity();

    @Select("select chinese,adcode,citycode from city")
    public List<Map> queryselect_info();

    @Select("select chinese,adcode from city limit #{curr},#{limit}")
    List<Map> queryInfox(@Param("curr")int curr, @Param("limit")int limit);

    @Select("select count(*) from city")
    int queryAllCountxx();
    @Select("select chinese from city where id=#{id}")
    String demo_get(int id);

}
